Filesystem and PG configuration

--001636c92a886f611a048835f039
Content-Type: text/plain; charset=ISO-8859-1

Can someone suggest some appropriate initial configuration parameters and
shared memory settings for the following hardware?

I'm running Debian on a Dell with 4x6 core CPU and 128GB memory and writing
to a coraid with 9 x 32GB SSDs RAID 10 using jfs with 8 drives active and 1
as spare.

I'm considering changing to xfs. I'm not sure what block size to use for
the file system, is 8192 appropriate? The OS page size is 4096.

The database is both write and read intensive, with about 750MB of new data
added per week and old deleted every six months to one year.

--001636c92a886f611a048835f039
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Can someone suggest some appropriate initial configuration paramete=
rs and shared memory settings for the following hardware?=A0

I'=
m running Debian on a Dell with 4x6 core CPU and 128GB memory and writing t=
o=A0 a coraid with 9 x 32GB SSDs RAID 10 using jfs with 8 drives active and=
1 as spare.=A0


I'm considering changing to xfs.=A0 I'm not sure what block siz=
e to use for the file system, is 8192 appropriate?=A0 The OS page size is 4=
096.

The database is both write and read intensive, with about 750MB=
of new data added per week and old deleted every six months to one year. r>





--001636c92a886f611a048835f039--

Re: Filesystem and PG configuration

On Fri, 4 Jun 2010 11:25:55 -0400
RBN wrote:

> Can someone suggest some appropriate initial configuration
> parameters and shared memory settings for the following hardware?
>
> I'm running Debian on a Dell with 4x6 core CPU and 128GB memory and
> writing to a coraid with 9 x 32GB SSDs RAID 10 using jfs with 8
> drives active and 1 as spare.
>
> I'm considering changing to xfs. I'm not sure what block size to
> use for the file system, is 8192 appropriate? The OS page size is
> 4096.
>
> The database is both write and read intensive, with about 750MB of
> new data added per week and old deleted every six months to one
> year.

A good start:

Tuning: http://www.westnet.com/~gsmith/content/postgresql/pgbench-sc aling.htm
Benchmark: http://edoceo.com/liber/db-postgresql-benchmark

Here's my benchmark on `m1.medium` instance of Amazon EC2:
http://gx.viettug.org/zen/kyanh/jobs/pgbench0.jpg.html

Good luck,

--
Anh Ky Huynh

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Filesystem and PG configuration

Hi,

pgtune could be the thing you're looking for.

http://pgfoundry.org/projects/pgtune/

regards

andreas


RBN wrote:
>
>
> Can someone suggest some appropriate initial configuration parameters
> and shared memory settings for the following hardware?
>
> I'm running Debian on a Dell with 4x6 core CPU and 128GB memory and
> writing to a coraid with 9 x 32GB SSDs RAID 10 using jfs with 8
> drives active and 1 as spare.
>
> I'm considering changing to xfs. I'm not sure what block size to use
> for the file system, is 8192 appropriate? The OS page size is 4096.
>
> The database is both write and read intensive, with about 750MB of new
> data added per week and old deleted every six months to one year.
>
>
>


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Filesystem and PG configuration

--0016363b8f0028467304889d4e56
Content-Type: text/plain; charset=ISO-8859-1

On Fri, Jun 4, 2010 at 7:53 PM, Anh Ky Huynh wrote:

>
> A good start:
>
> Tuning:
> http://www.westnet.com/~gsmith/content/postgresql/pgbench-sc aling.htm
> Benchmark: http://edoceo.com/liber/db-postgresql-benchmark
>
> Here's my benchmark on `m1.medium` instance of Amazon EC2:
> http://gx.viettug.org/zen/kyanh/jobs/pgbench0.jpg.html
>
>
Anh,

Were you using a EBS device in EC2 for that benchmark?

-Greg

--0016363b8f0028467304889d4e56
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Fri, Jun 4, 2010 at 7:53 PM, Anh Ky Huynh < =3D"mailto:xkyanh@gmail.com">xkyanh@gmail.com> wrote:
class=3D"gmail_quote">

ft: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: =
1ex;">

A good start:



Tuning: nch-scaling.htm" target=3D"_blank">http://www.westnet.com/~gsmith/content/p=
ostgresql/pgbench-scaling.htm

Benchmark: et=3D"_blank">http://edoceo.com/liber/db-postgresql-benchmar k



Here's my benchmark on `m1.medium` instance of Amazon EC2:

=A0 =A0 =A0 =A0 g.html" target=3D"_blank">http://gx.viettug.org/zen/kyanh/jobs/pgben ch0.jpg=
..html